CREATE TABLE {TABLE_NAME}
(
ID_CONTENT NUMBER(19, 2) NOT NULL
, ID_CONTENT_POOL NUMBER(10, 0) NOT NULL
, DATA_SIZE NUMBER(10, 0)
, EXTENSION VARCHAR2(255 BYTE)
, FILE_HASH VARCHAR2(255 BYTE)
, FILE_HASH_METHOD VARCHAR2(255 BYTE)
, FILE_NAME VARCHAR2(255 BYTE)
, ID_USER NUMBER(19, 0)
, INSERTED DATE
, META_DATA CLOB
, MIME_TYPE VARCHAR2(255 BYTE)
, ORIGINAL_FILE_PATH VARCHAR2(255 BYTE)
, STORAGE_NAME VARCHAR2(255 BYTE) NOT NULL
, TITLE VARCHAR2(255 BYTE)
, UUID VARCHAR2(255 BYTE)
, TRANSFORMATION NUMBER(10, 0) NOT NULL
)

/

CREATE SEQUENCE seq_{TABLE_NAME}

/

CREATE OR REPLACE TRIGGER bir_{TABLE_NAME}
BEFORE INSERT ON {TABLE_NAME}
FOR EACH ROW

BEGIN
  SELECT seq_{TABLE_NAME}.NEXTVAL
  INTO   :new.ID_CONTENT
  FROM   dual;
END;

/